-
Re: Formula for a parent row to populate status based on children status
HI @alexis.ray89371 try this: =IF( COUNTIF(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started", IF( COUNTIF(CHILDREN(), "Completed") = COUNT(CHILDREN()), "…2 · -
Re: Formula not returning value as expected
Hi @Beth Fantozzi 1 I think when you add in new rows the formula is seeing the blank ID Numbers as duplicates, try this formula to account for this: =IF([ID Number]@row <> "", IF(COUN…1 · -
Re: NEW! Dashboards Design Enhancements
I want to see your newest dashboard designs utilizing the new features! Inspire us! 🤩2 · -
Re: Automated emails are including data I don't want/need
@KimTDSYN Does it work to add a new column to the sheet with the URL link to the sheet and then hide it? Then you can include it in the message only with the brackets.1 · -
Re: Using COUNTIF, referencing data in a different sheet
The reason you are getting the "#Invalid Ref" error in your formula is that you are using the wrong syntax for the COUNTIF function. The correct syntax for the COUNTIF function in Smartshee…1 ·